CREATE PROCEDURE GetFromProveedorByNombre
@raz_soc varchar(30)
AS
BEGIN
SELECT *
FROM Proveedor
WHERE upper(Razon_Social) LIKE upper('%'+@raz_soc+'%')
END